package aaa.database;

import aaa.util.Messages;

/**
 * Interface containing all the constants sued in database transactions.
 * 
 * @author 		Schnell Michaël, Zanette Sébastien
 */
public interface DatabaseConstants {

	/* ******************************************************************************* *\
	
	                             General database
	
	\* ******************************************************************************* */
	public static final String NOM_BDD = Messages.getString("DatabaseConstants.0") ; //$NON-NLS-1$
	public static final int VERSION_BDD = 1 ;

	/* ******************************************************************************* *\
	
	                             Table Schedule
	
	\* ******************************************************************************* */
	// Table name
	public static final String TABLE_SCHEDULE = Messages.getString("DatabaseConstants.1") ; //$NON-NLS-1$
	// Table columns
	public static final String SCH_COL_NAME         = Messages.getString("DatabaseConstants.2") ; //$NON-NLS-1$
	public static final String SCH_COL_PROJECT_ID   = Messages.getString("DatabaseConstants.3") ; //$NON-NLS-1$
	public static final String SCH_COL_RESSOURCE_ID = Messages.getString("DatabaseConstants.4") ; //$NON-NLS-1$
	public static final String SCH_COL_PERIOD       = Messages.getString("DatabaseConstants.5") ; //$NON-NLS-1$
	public static final String SCH_COL_LAST_MODIF   = Messages.getString("DatabaseConstants.6") ; //$NON-NLS-1$
	public static final String SCH_COL_NOTIFY       = Messages.getString("DatabaseConstants.7") ; //$NON-NLS-1$
	public static final String SCH_COL_CREATED      = Messages.getString("DatabaseConstants.8") ; //$NON-NLS-1$
	public static final String SCH_COL_STATUS       = Messages.getString("DatabaseConstants.26") ; //$NON-NLS-1$
	// Table column index
	public static final int SCH_NUM_COL_NAME         = 0 ;
	public static final int SCH_NUM_COL_PROJECT_ID   = 1 ;
	public static final int SCH_NUM_COL_RESSOURCE_ID = 2 ;
	public static final int SCH_NUM_COL_PERIOD       = 3 ;
	public static final int SCH_NUM_COL_LAST_MODIF   = 4 ;
	public static final int SCH_NUM_COL_NOTIFY       = 5 ;
	public static final int SCH_NUM_COL_CREATED      = 6 ;
	public static final int SCH_NUM_COL_STATUS       = 7 ;

	/* ******************************************************************************* *\
	
	                             Table Lesson
	
	\* ******************************************************************************* */
	// Table name
	public static final String TABLE_LESSON = Messages.getString("DatabaseConstants.9") ; //$NON-NLS-1$
	// Table columns
	public static final String LES_COL_LESSON_ID  = Messages.getString("DatabaseConstants.10") ; //$NON-NLS-1$
	public static final String LES_COL_TITLE      = Messages.getString("DatabaseConstants.11") ; //$NON-NLS-1$
	public static final String LES_COL_TIME       = Messages.getString("DatabaseConstants.12") ; //$NON-NLS-1$
	public static final String LES_COL_SCHEDULE   = Messages.getString("DatabaseConstants.13") ; //$NON-NLS-1$
	public static final String LES_COL_TYPE       = Messages.getString("DatabaseConstants.14") ; //$NON-NLS-1$
	public static final String LES_COL_ROOM       = Messages.getString("DatabaseConstants.15") ; //$NON-NLS-1$
	public static final String LES_COL_GROUP      = Messages.getString("DatabaseConstants.16") ; //$NON-NLS-1$
	public static final String LES_COL_TEACHER    = Messages.getString("DatabaseConstants.17") ; //$NON-NLS-1$
	public static final String LES_COL_LAST_MODIF = Messages.getString("DatabaseConstants.18") ; //$NON-NLS-1$
	// Table coloumn index
	public static final int LES_NUM_COL_LESSON_ID  = 0 ;
	public static final int LES_NUM_COL_TITLE      = 1 ;
	public static final int LES_NUM_COL_TIME       = 2 ;
	public static final int LES_NUM_COL_SCHEDULE   = 3 ;
	public static final int LES_NUM_COL_TYPE       = 4 ;
	public static final int LES_NUM_COL_LAST_MODIF = 5 ;
	public static final int LES_NUM_COL_ROOM       = 6 ;
	public static final int LES_NUM_COL_GROUP      = 7 ;
	public static final int LES_NUM_COL_TEACHER    = 8 ;
	
	/* ******************************************************************************* *\
	
                                   Table Institution
	
	\* ******************************************************************************* */
	// Table name
	public static final String TABLE_INSTITUTION = Messages.getString("DatabaseConstants.19") ; //$NON-NLS-1$
	// Table columns
	public static final String INST_COL_ID   = Messages.getString("DatabaseConstants.20") ; //$NON-NLS-1$
	public static final String INST_COL_NAME = Messages.getString("DatabaseConstants.21") ; //$NON-NLS-1$
	// Table column index
	public static final int INST_NUM_COL_ID   = 0 ;
	public static final int INST_NUM_COL_NAME = 1 ;
	
	/* ******************************************************************************* *\
	
	                               Table Room
	
	\* ******************************************************************************* */
	// Table name
	public static final String TABLE_ROOM = Messages.getString("DatabaseConstants.22") ; //$NON-NLS-1$
	// Table columns
	public static final String ROOM_COL_ID          = Messages.getString("DatabaseConstants.23") ; //$NON-NLS-1$
	public static final String ROOM_COL_INSTITUTION = Messages.getString("DatabaseConstants.24") ; //$NON-NLS-1$
	public static final String ROOM_COL_NAME        = Messages.getString("DatabaseConstants.25") ; //$NON-NLS-1$
	// Table column index
	public static final int ROOM_NUM_COL_ID          = 0 ;
	public static final int ROOM_NUM_COL_INSTITUTION = 1 ;
	public static final int ROOM_NUM_COL_NAME        = 2 ;

}// interface DatabaseConstants